CREATE PROCEDURE spSelectPersonByID
   @PersonID INT
AS
BEGIN
   SELECT
      *
   FROM
      tblPersons
   WHERE
      PersonID = @PersonID
END
GO